//TBWM01AI JOB (0371,TEST,,999),'71P000',CLASS=T,NOTIFY=TBWM01A,
//         MSGCLASS=Q,REGION=1300K
/*ROUTE PRINT LOCAL
//**********************************************************
//SPUFI OUTPUT CLASS=A,COPIES=1,DEST=LOCAL,
//             FORMS=,FCB=,UCS=
//SPUFIGO  EXEC PGM=IKJEFT01,
//     DYNAMNBR=30,
//       REGION=3M
//STEPLIB  DD  DISP=SHR,DSN=DSN1.DB2.TEST.DSNLOAD
//SYSUDUMP DD  SYSOUT=*
//SYSTSPRT DD  SYSOUT=*
//SYSPRINT DD  SYSOUT=*
//SYSABOUT DD  SYSOUT=*
//SYSDBOUT DD  SYSOUT=*
//SYSOUT   DD  SYSOUT=*
//SYSTSIN  DD *
DSN SYSTEM(DB2T)
 RUN PROGRAM(DSNTEP2) PLAN(DSNTEP2) -
     LIB('DSN1.DB2.TEST.DSNLOAD')
/*
//SYSIN    DD *
DROP INDEX TBWM01A.X000000A;
DROP INDEX TBWM01A.X000001A;
DROP INDEX TBWM01A.X000002A;
DROP INDEX TBWM01A.X000003A;
DROP INDEX TBWM01A.X000004A;
DROP INDEX TBWM01A.X000005A;
DROP INDEX TBWM01A.X000006A;
DROP INDEX TBWM01A.X000007A;
DROP INDEX TBWM01A.X000008A;
DROP INDEX TBWM01A.X000009A;
DROP INDEX TBWM01A.X000010A;
DROP INDEX TBWM01A.X000011A;
DROP INDEX TBWM01A.X000012A;
DROP INDEX TBWM01A.X000013A;
DROP INDEX TBWM01A.X000014A;
COMMIT;
CREATE        INDEX TBWM01A.X000000A
          ON TBWM01A.VWIVCPTD
             (BITM_NUM)
                  CLUSTER
                  USING STOGROUP VSMTQD2A
                  PRIQTY   500   SECQTY    50
                  FREEPAGE 0 PCTFREE 10
                  SUBPAGES   1
                  BUFFERPOOL BP3
                  CLOSE      NO;
CREATE        INDEX TBWM01A.X000001A
          ON TBWM01A.DPAC
             (BITM_NUMB)
                  CLUSTER
                  USING STOGROUP VSMTQD2A
                  PRIQTY   500   SECQTY    50
                  FREEPAGE 0 PCTFREE 10
                  SUBPAGES   1
                  BUFFERPOOL BP3
                  CLOSE      NO;
CREATE        INDEX TBWM01A.X000002A
          ON TBWM01A.DPAC_CONT
             (BITM_NUMB_PACK)
                  CLUSTER
                  USING STOGROUP VSMTQD2A
                  PRIQTY   500   SECQTY    50
                  FREEPAGE 0 PCTFREE 10
                  SUBPAGES   1
                  BUFFERPOOL BP3
                  CLOSE      NO;
CREATE        INDEX TBWM01A.X000003A
          ON TBWM01A.ORGU
             (USER_INTF_NUMB)
                  CLUSTER
                  USING STOGROUP VSMTQD2A
                  PRIQTY   500   SECQTY    50
                  FREEPAGE 0 PCTFREE 10
                  SUBPAGES   1
                  BUFFERPOOL BP3
                  CLOSE      NO;
CREATE        INDEX TBWM01A.X000004A
          ON TBWM01A.SOS_GRP_EXT_INTF
             (ORGU_NUMB)
                  CLUSTER
                  USING STOGROUP VSMTQD2A
                  PRIQTY   500   SECQTY    50
                  FREEPAGE 0 PCTFREE 10
                  SUBPAGES   1
                  BUFFERPOOL BP3
                  CLOSE      NO;
CREATE        INDEX TBWM01A.X000005A
          ON TBWM01A.SOS
             (BITM_NUMB, ORGU_NUMB)
                  CLUSTER
                  USING STOGROUP VSMTQD2A
                  PRIQTY   500   SECQTY    50
                  FREEPAGE 0 PCTFREE 10
                  SUBPAGES   1
                  BUFFERPOOL BP3
                  CLOSE      NO;
CREATE        INDEX TBWM01A.X000006A
          ON TBWM01A.DPAC_TO_STIT
             (BITM_NUMB)
                  CLUSTER
                  USING STOGROUP VSMTQD2A
                  PRIQTY   500   SECQTY    50
                  FREEPAGE 0 PCTFREE 10
                  SUBPAGES   1
                  BUFFERPOOL BP3
                  CLOSE      NO;
CREATE        INDEX TBWM01A.X000007A
          ON TBWM01A.IH_STIT
             (STIT_NUMB)
                  CLUSTER
                  USING STOGROUP VSMTQD2A
                  PRIQTY   500   SECQTY    50
                  FREEPAGE 0 PCTFREE 10
                  SUBPAGES   1
                  BUFFERPOOL BP3
                  CLOSE      NO;
CREATE        INDEX TBWM01A.X000008A
          ON TBWM01A.STIT_ITMG_IN_STRC
             (STIT_NUMB)
                  CLUSTER
                  USING STOGROUP VSMTQD2A
                  PRIQTY   500   SECQTY    50
                  FREEPAGE 0 PCTFREE 10
                  SUBPAGES   1
                  BUFFERPOOL BP3
                  CLOSE      NO;
CREATE        INDEX TBWM01A.X000009A
          ON TBWM01A.IH_ITMG
             (ITGT_CODE, ITMG_UNUM)
                  CLUSTER
                  USING STOGROUP VSMTQD2A
                  PRIQTY   500   SECQTY    50
                  FREEPAGE 0 PCTFREE 10
                  SUBPAGES   1
                  BUFFERPOOL BP3
                  CLOSE      NO;
CREATE        INDEX TBWM01A.X000010A
          ON TBWM01A.AUTH_SOS
             (BITM_NUMB)
                  CLUSTER
                  USING STOGROUP VSMTQD2A
                  PRIQTY   500   SECQTY    50
                  FREEPAGE 0 PCTFREE 10
                  SUBPAGES   1
                  BUFFERPOOL BP3
                  CLOSE      NO;
CREATE        INDEX TBWM01A.X000011A
          ON TBWM01A.ORGU
             (ORGU_NUMB)
                  USING STOGROUP VSMTQD2A
                  PRIQTY   500   SECQTY    50
                  FREEPAGE 0 PCTFREE 10
                  SUBPAGES   1
                  BUFFERPOOL BP3
                  CLOSE      NO;
CREATE        INDEX TBWM01A.X000012A
          ON TBWM01A.VITEMLUCKYSR
             (STIT_NUMB)
                  CLUSTER
                  USING STOGROUP VSMTQD2A
                  PRIQTY   500   SECQTY    50
                  FREEPAGE 0 PCTFREE 10
                  SUBPAGES   1
                  BUFFERPOOL BP3
                  CLOSE      NO;
CREATE        INDEX TBWM01A.X000013A
          ON TBWM01A.VITEMLUCKYNR
             (STIT_NUMB)
                  CLUSTER
                  USING STOGROUP VSMTQD2A
                  PRIQTY   500   SECQTY    50
                  FREEPAGE 0 PCTFREE 10
                  SUBPAGES   1
                  BUFFERPOOL BP3
                  CLOSE      NO;
CREATE        INDEX TBWM01A.X000014A
          ON TBWM01A.VVNDRLUCKYSR
             (ORGU_NUMB)
                  USING STOGROUP VSMTQD2A
                  PRIQTY   500   SECQTY    50
                  FREEPAGE 0 PCTFREE 10
                  SUBPAGES   1
                  BUFFERPOOL BP3
                  CLOSE      NO;
//
